Endowing NoSQL DBMS with SQL Features Through Standard Call Level Interfaces
نویسندگان
چکیده
To store, update and retrieve data from database management systems (DBMS), software architects use tools, like call-level interfaces (CLI), which provide standard functionalities to interact with DBMS. However, the emerging of NoSQL paradigm, and particularly new NoSQL DBMS providers, lead to situations where some of the standard functionalities provided by CLI are not supported, very often due to their distance from the relational model or due to design constraints. As such, when a system architect needs to evolve, namely from a relational DBMS to a NoSQL DBMS, he must overcome the difficulties conveyed by the features not provided by NoSQL DBMS. Choosing the wrong NoSQL DBMS risks major issues with components requesting non-supported features. This paper focuses on how to deploy features that are not so commonly supported by NoSQL DBMS (like Stored Procedures, Transactions, Save Points and interactions with local memory structures) by implementing them in standard CLI. Keywords—NoSQL; SQL; databases; middle-ware; call level interfaces;software architecture.
منابع مشابه
Concurrent Call Level Interfaces Based on an Embedded Thread Safe Local Memory Structure
Performance is traditionally considered one of the most significant concerns in intensive database applications. Several architectural tactics may be taken to minimize the possibility of coming across with any performance bottleneck. One of them is the usage of Call Level Interfaces (CLI). CLI are low level API that provide a high performance environment to execute SQL statements on relational ...
متن کاملScalable Persisting and Querying of Streaming Data by Utilizing a NoSQL Data Store
Relational databases provide technology for scalable queries over persistent data. In many application scenarios a problem with conventional relational database technology is that loading large data logs produced at high rates into a database management system (DBMS) may not be fast enough, because of the high cost of indexing and converting data during loading. As an alternative a modern index...
متن کاملNew Database Architectures: Steps towards Big Data Processing
Both research and practice indicate that traditional universal DBMS architecture hardly satisfies new trends in data processing, particularly in the context of cloud computing and Big Data problems. New database architectures and their basic features will be described, particularly their horizontal scalability and concurrency model, which is mostly weaker than ACID transactions in relational SQ...
متن کاملOdysseus/DFS: Integration of DBMS and Distributed File System for Transaction Processing of Big Data
The relational DBMS (RDBMS) has been widely used since it supports various high-level functionalities such as SQL, schemas, indexes, and transactions that do not exist in the O/S file system. But, a recent advent of big data technology facilitates development of new systems that sacrifice the DBMS functionality in order to efficiently manage large-scale data. Those so-called NoSQL systems use a...
متن کاملSQL for NoSQL Databases: Déjà Vu
Existing relational database technology experience tells us that declarative database query languages are beneficial for different reasons, including application independence from access path considerations and decades of sophisticated query optimization technologies [2]. In context of most NoSQL databases, however, users are forced to implement complex query algorithms manually themselves usin...
متن کامل